﻿SET QUOTED_IDENTIFIER OFF;
GO
USE [AircraftBattle];
GO
IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]');
GO

delete from armors;
delete from weapons;
delete from aircraft;
delete from aircraft_type;
delete from users;

insert into armors (protection,weight) values ('5','10');
insert into armors (protection,weight) values ('10','5');
insert into weapons (damage,shoot_rate,bullet_type,bullet_speed,bullet_size) values ('5','5','1','1','1');
insert into weapons (damage,shoot_rate,bullet_type,bullet_speed,bullet_size) values ('10','5','2','2','2');
insert into aircraft (armor_id,speed,type,weapon_id) values ('0','5','1','0');
insert into aircraft (armor_id,speed,type,weapon_id) values ('1','5','2','1');
insert into aircraft_type (default_speed,default_weapon_id,default_armor_id,image,name) values ('1','0','0','basic','basic');
insert into aircraft_type (default_speed,default_weapon_id,default_armor_id,image,name) values ('2','0','0','black','strong');
insert into aircraft_type (default_speed,default_weapon_id,default_armor_id,image,name) values ('3','0','0','white','super');
insert into users (isadmin,name,password,win,lose,blocked,craftid,kills,credit) values ('1','martin','mazhou','1','0','0','1','1','1000');
insert into users (isadmin,name,password,win,lose,blocked,craftid,kills,credit) values ('1','mark','zhouma','0','1','0','2','0','0');
